package com.icity.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.icity.entity.ArticleStatistical;
import com.icity.entity.VideoStatistical;

/**
 * 
 * @author apple
 */
@Mapper
public interface VideoStatisticalMapper {
  
	
    
    
	
    @Select("select video_num,video_read_num,video_comments_num,video_collect_num,video_forward_num,video_like_num,video_read_people_num from tbl_icity_video_statistical where application_unique_code=#{application_unique_code} and partner_id=#{partner_id} and type=#{type} and create_time BETWEEN statrt_time=#{statrt_time} and end_time=#{end_time}")
	List<VideoStatistical> getOverallVideo(Map<Object, Object> map);
    @Select("select video_num,video_read_num,video_comments_num,video_collect_num,video_forward_num,video_like_num,video_read_people_num from tbl_icity_video_statistical where application_unique_code=#{application_unique_code} and partner_id=#{partner_id} and type=#{type} and create_time BETWEEN statrt_time=#{statrt_time} and end_time=#{end_time}")
	List<VideoStatistical> getTrendVideo(Map<Object, Object> map);


	
	
}
